﻿CREATE TABLE [dbo].[NewsItems] (
    [Id]                                      NVARCHAR (100) NOT NULL,
    [Source]                                  NVARCHAR (MAX) NOT NULL,
    [Title]                                   NVARCHAR (MAX) NOT NULL,
    [Date]                                    DATETIME       NOT NULL,
    [IndexedContent]                          NVARCHAR (MAX) NOT NULL,
    [Summary]                                 NVARCHAR (MAX) NOT NULL,
    [Chamber]                                 NVARCHAR (MAX) NOT NULL,
    [Committee_Id]                            NVARCHAR (100) NULL,
    [NewsItemGenericSearchResult_NewsItem_Id] NVARCHAR (100) NOT NULL
);

